How to import .DBF file into ACCESS

[Metcare]

Hi ,

I am trying to import a .dbf file (3Mb) to Access 2000, my fisrt time to
import .dbf, I always import .XLS files,. I am not successful importing the
.dbf as I am getting this error:
"The microsoft engine jet cannot find the object . Make sure the object
exists and that you spell its name and the path correctly".

The icon of the file is on the list and I just select it , but still it
cannot locate it.
Greatly appreciate your help. Thanks in advance.

[Arvin Meyer [MVP]]

There may be a problem with the version of dbf file. There may also be a
problem with Access not finding the index file. If you continue to have
trouble, try saving the file as text or csv and import that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Metcare" <Met...@discussions.microsoft.com> wrote in message
news:102A1721-E59F-4F5B...@microsoft.com...

[John W. Vinson]

How are you trying to import it? What specific steps?

What I'd do is use File... Get External Data... Import; change "Files of type"
to the correct version of dBase. There are several versions - dBase III, dBase
IV, dBase 5.0, FoxPro, Visual FoxPro all use the .dbf extension but the files
have different internal structure.
--

John W. Vinson [MVP]

[Metcare]

Yes, that's what I did, I tried selecting the different .dbf file types, but
am not successful. We do not have FOXpro or DBase programs to open it and
save it to a .csv or .txt. We just received this file from our provider. I
tried opening it in EXCEL but got truncated after 60K+++ records where
downloaded, and this file contains more than 60K records. I don't think
EXCEL can download all the records as the file is too big. Thanks

[Arvin Meyer [MVP]]

Excel 2007 can handle about 1 million rows. It may be the way to get what
you need.

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Metcare" <Met...@discussions.microsoft.com> wrote in message

news:30006B77-48C5-4B17...@microsoft.com...

[Metcare]

Thank you for your advise.

[vharris835]

I got this error message trying to import a table into Access 2003 also. I
changed the name of the dbase file to only have the 8 character naming
convention (eg. 12345678.dbf) and it imported successfully. Are you unable
to import files with long names?

[Metcare]

Dear Vharris835

It worked!!! I just changed the names of the database files to 8 characters
and was able to import successful. Can't believe how simple the solution is.
I 've been using the workaround solution by converting the .DBF files to .csv
using my Excel 2007 at home as I have 2003 version at work. Now I do not need
to bring them home , just rename the files and viola! able to import them.
Works like a charm!
Thank you everybody for your help.

[Douglas J. Steele]

Actually, it may not even be necessary to rename the file.

http://www.mvps.org/access/api/api0020.htm at "The Access Web" includes code
to return the short file name for any long file name. I believe you can
simply determine the short file name and use it.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Metcare" <Met...@discussions.microsoft.com> wrote in message

news:42D5C785-1790-4C29...@microsoft.com...